home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
AOL File Library: 4,101 to 4,200
/
aol-file-protocol-4400-4101-to-4200.zip
/
AOLDLs
/
Business Management
/
ACS7_ V7.0 Mechanic's Scheduler
/
MECHANIC.exe
/
MECH-W70.EXE
/
MECHANIC.WIN
/
SBT.DOC
< prev
next >
Wrap
Text File
|
1989-03-13
|
6KB
|
144 lines
SBT [TM] Customer File Menu
Overview:
Thi≤á optioεá wil∞ creatσ record≤ iε thσ SB╘ [TM▌ Custome≥ Filσ forma⌠á anΣ ì
theεá appenΣá theφá t∩ thσ SB╘ [TM▌ Custome≥ filσ iεá thσá \SB╘á drivσá anΣ ì
subdirector∙ oµ you≥ choice.
Optionally¼á yo⌡ caε ß selec⌠ additiona∞ selectioε criteriß specifiπ t∩ SB╘ ì
[TM].
Oncσá thσá ne≈á record≤ froφ thi≤ prograφ arσ appendeΣ int∩á thσá SB╘á [TM▌ ì
Custome≥ file¼á yo⌡ mus⌠ reinde° thosσ file≤ withiε SB╘ [TM]«á T∩ d∩ this¼ ì
brinτá u≡ thσ Maiε Men⌡ oµ dInvoice/dStatement≤ [TM▌á III¼á v.6.20¼á selec⌠ ì
optioε U║á Utilit∙ Menu« A⌠ thσ Utilit∙ Menu¼ selec⌠ optioε 1║ Reinde° Al∞ ì
Files.
==============
| OPTION 1: |
==============
1) Output to Customer File
[dInvoice/dStatements III v.6.20]
Fields created automatically in SBT [TM] file during conversion:
with fields from which data is drawn in PROSPECT.DBF
Structure of ARCUST.DBF
Structure for database: ARCUST Corresponding fields in PROSPECT.DBF:
Field Field Name Type Width Dec
1 CUSTNO Character 6 <==== created from PROSPECT field
2 COMPANY Character 35 <==== from PROSPECT field
3 CONTACT Character 20 <==== from FNAME + LNAME field
4 TITLE Character 20
5 ADDRESS1 Character 30 <==== from ADDRESS1 field
6 ADDRESS2 Character 30 <==== from ADDRESS2 field
7 CITY Character 20 <==== from CITY field
8 STATE Character 10 <==== from STATE field
9 ZIP Character 10 <==== from ZIP field
10 COUNTRY Character 15
11 PHONE Character 20 <==== from PHONE_1 field
12 TERR Character 2
13 INDUST Character 5
14 SALESMN Character 2
15 SOURCE Character 5
16 CODE Character 2
17 TYPE Character 8
18 PTERMS Character 20
19 PDISC Numeric 7 3
20 PDAYS Numeric 3
21 PNET Numeric 3è 22 SVC Numeric 7 3
23 TAX Numeric 7 3
24 DISC Numeric 7 3
25 LDATE Character 8
26 LASTPAY Character 8
27 ENTERED Character 8
28 LIMIT Numeric 7
29 BALANCE Numeric 12 2
30 PTDSLS Numeric 12 2
31 YTDSLS Numeric 12 2
32 ONORDER Numeric 12 2
33 CREDIT Numeric 12 2
34 LPYMT Numeric 12 2
35 LSALE Numeric 12 2
36 GLLINK Character 3
37 COMMENT Character 65 <==== from COMMENT1 + COMMENT2 field
38 HISTORY Character 1
39 PRICECODE Character 1
40 TAXCODE Character 1
41 CURRENCY Character 3
42 FLAGS Character 10
43 CSTNUM1 Numeric 9
44 CSTNUM2 Numeric 9
45 SIGNATURE Numeric 2
** Total ** 514
Logic behind creation of CUSTNO field in SBT [TM] file:
two step process
Thσ prograφ firs⌠ look≤ t∩ seσ iµ yo⌡ havσ entereΣ thi≤ phrasσ int∩á eithe≥ ì
COMMENT▒ o≥ COMMENT2║á "CUSTNO='«á Iµ thi≤ codσ i≤ present¼á theε thσ si° ì
character≤á followinτ "CUSTNO=ó arσ placeΣ int∩ thσ correspondinτ SB╘á [TM▌ ì
record.
Secondly¼á thσá prograφá wil∞ creatσ ß fou≥ characte≥ codσ iεá CUSTN╧á tha⌠ ì
adhere≤ t∩ thσ followinτ logic:
1) The fourth character will be a '1'
2⌐á Thσ firs⌠ threσ character≤ wil∞ bσ takeε froφ thσ firs⌠ lette≥ oµá eacΦ ì
namσ froφ thσ compan∙ namσ o≥ PROSPEC╘ field.
3) The following articles are dropped from the company name during step 2:
A AN IN OR & THE OF FOR WITH
4⌐ Iµ thσ resultinτ word≤ iε thσ compan∙ namσ numbe≥ les≤ thaε 3¼ theε thσ ì
remaininτ character≤ arσ takeε a≤ needeΣ froφ thσ las⌠ completσ worΣ iε thσ ì
compan∙ name«
Examples:
[taken from test data]
CUSTNO Company name:è
ATS1 Accounting & Tax Service
ADD1 Addmaster/Marchant
FDS1 Fourcolor Data Systems
LLE1 Lolir Lectronics
MDC1 Micro Distribution Center
NAI1 North American Investment Corp.
PBO1 P.O. BOX
REV1 Rex Evilsizor
SEL1 Sabet Electronics
TCP1 Texas Commerce Plumbing
==============
| OPTION 2: |
==============
2) Additional selection criteria specific to SBT [TM]:
A⌠ thi≤ menu¼á yo⌡ caε ente≥ value≤ whicΦ wil∞ bσ placeΣ iε al∞ record≤ no≈ ì
beinτá outputteΣ t∩ thσ SB╘ [TM▌ custome≥ file«á Thesσ arσ field≤ ove≥ anΣ ì
beyonΣ thσ minima∞ field≤ beinτ createΣ iε eacΦ SB╘ [TM▌ custome≥ record.
These optional fields are:
TERR GLLINK
INDUST HISTORY
SALESMN PRICECOD
SOURCE TAXCODE
CODE CURRENCY
TYPE FLAGS
PTERMS LIMIT